{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Tri croisé","Covariance"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Tri croisé","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5]]}
[{"$f":"PropriétésClasseur()","v":"Classeur G:\\_Stat\\_Cours perso\\Classeurs Excel\\02_Les distributions statistiques.xlsm"}]
["Enregistré le 04/06/2010 10:40:09"]
[]
[]
["             Montant A des achats :\nNb n de commandes :","A ≤ 1000","1000 < A ≤ 2500","2500  < A ≤ 5000","5000 < A","Ensemble :"]
[]
["           n ≤ 10",20,45,120,10,{"$f":"SUM(B7:E7)","v":195}]
["  10 < n ≤ 50",15,60,220,90,{"$f":"SUM(B8:E8)","v":385}]
["  50 < n ≤ 100",10,35,200,45,{"$f":"SUM(B9:E9)","v":290}]
["100 < n",5,10,110,5,{"$f":"SUM(B10:E10)","v":130}]
["Ensemble :",{"$f":"SUM(B7:B10)","v":50},{"$f":"SUM(C7:C10)","v":150},{"$f":"SUM(D7:D10)","v":650},{"$f":"SUM(E7:E10)","v":150},{"$f":"SUM(F7:F10)","v":1000}]
[]
[]
["               Nb n de commandes :\nMontant A des achats :","n ≤ 10","10 < n ≤ 50","50 < n ≤ 100","100 < n","Ensemble :"]
["             A ≤ 1000",20,15,10,5,{"$f":"SUM(B15:E15)","v":50}]
["1000 < A ≤ 2500",45,60,35,10,{"$f":"SUM(B16:E16)","v":150}]
["2500 < A ≤ 5000",120,220,200,110,{"$f":"SUM(B17:E17)","v":650}]
["5000 < a",10,90,45,5,{"$f":"SUM(B18:E18)","v":150}]
["Ensemble :",{"$f":"SUM(B15:B18)","v":195},{"$f":"SUM(C15:C18)","v":385},{"$f":"SUM(D15:D18)","v":290},{"$f":"SUM(E15:E18)","v":130},{"$f":"SUM(F15:F18)","v":1000}]
[]
[]
[]
["                        Âge â du client :\nMontant A des achats :","â ≤ 18","18 < â ≤ 25","25 < â ≤ 40","40 < â","Ensemble :"]
[]
["             A ≤ 1000",25,10,10,5,{"$f":"SUM(B25:E25)","v":50}]
[" 1000 < A ≤ 2500",40,60,30,20,{"$f":"SUM(B26:E26)","v":150}]
[" 2500 < A ≤ 5000",30,150,250,220,{"$f":"SUM(B27:E27)","v":650}]
[" 5000 < A",20,70,45,15,{"$f":"SUM(B28:E28)","v":150}]
["Ensemble :",{"$f":"SUM(B25:B28)","v":115},{"$f":"SUM(C25:C28)","v":290},{"$f":"SUM(D25:D28)","v":335},{"$f":"SUM(E25:E28)","v":260},{"$f":"SUM(B29:E29)","v":1000}]
[]
[]
["              Montant A des achats :\nÂge â du client :","A ≤ 1000"," 1000 < A ≤ 2500"," 2500 < A ≤ 5000"," 5000 < A","Ensemble :"]
[]
["â ≤ 18",25,40,30,20,{"$f":"SUM(B34:E34)","v":115}]
["18 < â ≤ 25",10,60,150,70,{"$f":"SUM(B35:E35)","v":290}]
["25 < â ≤ 40",10,30,250,45,{"$f":"SUM(B36:E36)","v":335}]
["40 < â",5,20,220,15,{"$f":"SUM(B37:E37)","v":260}]
["Ensemble :",{"$f":"SUM(B34:B37)","v":50},{"$f":"SUM(C34:C37)","v":150},{"$f":"SUM(D34:D37)","v":650},{"$f":"SUM(E34:E37)","v":150},{"$f":"SUM(F34:F37)","v":1000}]

{"sheet":"Covariance","index":1,"n_rows":18,"n_cols":22,"rows_kept":18}
[{"$f":"PropriétésClasseur()","v":"Classeur G:\\_Stat\\_Cours perso\\Classeurs Excel\\02_Les distributions statistiques.xls"}]
["Enregistré le 13/12/2009 16:28:13"]
[]
[]
["Y1 = ",-10,-9,-8,-7,-6,-5,-4,-3,-2,-1,0,1,2,3,4,5,6,7,8,9,10]
["Y2 = ",{"$f":"B5*B5","v":100},{"$f":"C5*C5","v":81},64,49,36,25,16,9,4,1,0,1,4,9,16,25,36,49,64,81,100]
[]
["cov(Y1; Y2) =",{"$f":"COVAR($B$5:$V$5,$B$6:$V$6)","v":{"v":-5.4136589391245725E-15,"d":" -0.000000 "}}]
["r(Y1; Y2) =",{"$f":"CORREL($B$5:$V$5,$B$6:$V$6)","v":{"v":-2.7354222320850152E-17,"d":" -0.000000 "}}]
[]
[null,"ordonnée à l'origine =",10]
[null,"pente =",5]
[]
["Y1 = ",-10,-9,-8,-7,-6,-5,-4,-3,-2,-1,0,1,2,3,4,5,6,7,8,9,10]
["Y2 = ",{"$f":"$C$11+$C$12*B14","v":-40},{"$f":"$C$11+$C$12*C14","v":-35},-30,-25,-20,-15,-10,-5,0,5,10,15,20,25,30,35,40,45,50,55,60]
[]
["cov(Y1; Y2) =",{"$f":"COVAR(B14:V14,B15:V15)","v":{"v":183.33333333333334,"d":"183.333333"}}]
["r(Y1; Y2) =",{"$f":"CORREL(B14:V14,B15:V15)","v":{"v":1.0000000000000002,"d":"1.000000"}}]